<!--
  This file is a part of the open-eBackup project.
  This Source Code Form is subject to the terms of the Mozilla Public License, v. 2.0.
  If a copy of the MPL was not distributed with this file, You can obtain one at
  http://mozilla.org/MPL/2.0/.
  
  Copyright (c) [2024] Huawei Technologies Co.,Ltd.
  
  THIS SOFTWARE IS PROVIDED ON AN "AS IS" BASIS, WITHOUT WARRANTIES OF ANY KIND,
  EITHER EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO NON-INFRINGEMENT,
  MERCHANTABILITY OR FIT FOR A PARTICULAR PURPOSE.
  -->


<!DOCTYPE html
  PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html lang="zh-cn" xml:lang="zh-cn">
<head>
      <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
   
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="DC.Type" content="topic">
<meta name="DC.Title" content="账户锁定导致资源接入、备份、恢复操作失败（适用于OLTP OPS）">
<meta name="product" content="">
<meta name="DC.Relation" scheme="URI" content="TPOPS_GaussDB_00063.html">
<meta name="prodname" content="">
<meta name="version" content="">
<meta name="brand" content="">
<meta name="DC.Publisher" content="20250306">
<meta name="prodname" content="csbs">
<meta name="documenttype" content="usermanual">
<meta name="DC.Format" content="XHTML">
<meta name="DC.Identifier" content="TPOPS_GaussDB_00077">
<meta name="DC.Language" content="zh-cn">
<link rel="stylesheet" type="text/css" href="public_sys-resources/commonltr.css">
<title>账户锁定导致资源接入、备份、恢复操作失败（适用于OLTP OPS）</title>
</head>
<body style="clear:both; padding-left:10px; padding-top:5px; padding-right:5px; padding-bottom:5px"><a name="TPOPS_GaussDB_00077"></a><a name="TPOPS_GaussDB_00077"></a>

<h1 class="topictitle1">账户锁定导致资源接入、备份、恢复操作失败（适用于OLTP OPS）</h1>
<div><div class="section"><h4 class="sectiontitle">现象描述</h4><p>GaussDB执行资源接入、备份或恢复等操作失败。</p>
</div>
<div class="section"><h4 class="sectiontitle">可能原因</h4><p>执行资源接入/备份/恢复操作时，由于TPOPS账户被锁定，导致操作失败。</p>
</div>
<div class="section"><h4 class="sectiontitle">背景信息</h4><p>本节操作步骤适用于使用OLTP OPS管理平台的场景，使用云数据库GaussDB管理平台（TPOPS）时，请参考对应产品文档的<span class="uicontrol">“锁定与解锁”</span>章节，文档获取地址如下：</p>
<ul><li>企业网：<a href="https://support.huawei.com/enterprise/zh/doc/EDOC1100349230" target="_blank" rel="noopener noreferrer">点此前往</a></li><li>运营商：<a href="https://support.huawei.com/carrier/docview?nid=DOC1101210821&amp;path=PBI1-253383977/PBI1-23710112/PBI1-23710137/PBI1-251517148" target="_blank" rel="noopener noreferrer">点此前往</a></li></ul>
</div>
<div class="section"><h4 class="sectiontitle">处理步骤</h4><ol><li><span>登录TPOPS Server的节点，执行<strong>su - dmuser</strong>命令切换到dmuser用户。</span></li><li><span>以dmuser用户执行以下命令连接到Info Store。</span><p><pre class="screen">source $HOME/.dmbashrc
source $DM_HOME/primdb/.infostore
gsql -d primdb -p <em>22202</em> -r -U <em>apprim</em> -W <em>password</em></pre>
<div class="note"><img src="public_sys-resources/note_3.0-zh-cn.png"><span class="notetitle"> </span><div class="notebody"><p>gsql命令中，“-p”和“-U”分别代表primdb的端口和primdb的admin用户，命令示例中为默认值，如果做了修改，可以在TPOPS安装包的存放目录下查看安装配置文件install-default.conf，通过参数“primdb.listen.port”和“primdb.dbuser”获取。可参考以下回显示例。</p>
<pre class="screen">...  
primdb.listen.port = 22202 ### (Range: 1024 - 65535; Default: 22202)  
primdb.dbuser = apprim ### admin User for Primary DB  
...</pre>
</div></div>
</p></li><li><span>执行如下命令解锁admin账户。</span><p><pre class="screen">UPDATE USER_MANAGEMENT.GA_PL_AU_USER SET LOCKED_DATE='',LOCK_STATUS=0, LOGIN_ATTEMPT=0, LOCKED_REASON='' WHEREUSERNAME='admin'; </pre>
<div class="note"><img src="public_sys-resources/note_3.0-zh-cn.png"><span class="notetitle"> </span><div class="notebody"><p>当解锁账户不为admin账户，可在TPOPS界面的“<span>系统管理</span> &gt; <span>用户</span> &gt; <span>用户管理</span>”中，在用户列表待解锁账户所在行单击“<span>解锁</span>”完成解锁操作。</p>
</div></div>
</p></li></ol>
</div>
</div>
<div>
<div class="familylinks">
<div class="parentlink"><strong>父主题：</strong> <a href="TPOPS_GaussDB_00063.html">常见问题</a></div>
</div>
</div>

<div class="hrcopyright"><hr size="2"></div><div class="hwcopyright">版权所有 &copy; 华为技术有限公司</div></body>
</html>